.. _`Replace values in Table with Table`:

.. _`org.sysess.sympathy.data.table.tablevaluesearchreplacewithtable`:

Replace values in Table with Table
``````````````````````````````````

.. image:: search_replace.svg
   :width: 48


Search and replace values in specified columns table with search expressions from a table




Documentation
:::::::::::::

Replacements will be performed in all selected columns.

Regex
=====
If *Text replace only (using regex)* is checked, the search expression may be
a regular expression. Here, it is possible to capture part of the match using
parentheses in the search expression. To reuse the part of the match within the
parentheses in the use ``\\1`` (or higher numbers) to insert matches.

As an example let's say that you have an input table with a column containing
the strings ``x_old``, ``y_old``, and ``z_old``. If you enter the search
expression ``(.*)_old`` and the replace expression ``\\1_new`` the output will
be the strings ``x_new``, ``y_new``, and ``z_new``.

Unless configured to use regex replacement, search, replace and default values
will be read as a values of the same type as the column it is replacing in.
For details about how to enter values for different types, see
:ref:`appendix_typed_text`.


Definition
::::::::::


Input ports
===========

    **expressions**  table
        Expressions

    **data**  table
        Table Data


Output ports
============

    **data**  table
        Table with replaced values




Configuration
=============

    **Columns to replace values in** (column)
        Select in which to perform replace
    **Column with search expressions** (find)
        Select which column contains search expressions
    **Ignore case** (ignore_case)
        Ignore case when searching
    **Text replace only (using regex)** (literal)
        Perform regex replacements in string columns, i.e., columns with types text and bytes, other columns are ignored. Disable this option to replace full values, without using regex across all types of columns.
    **Column with replace expressions** (replace)
        Select which column contains replacements







Examples
========

* :download:`ReplaceValuesInTable.syx </_examples/Sympathy/Data Processing/Data/ReplaceValuesInTable.syx>`



Implementation
==============

.. automodule:: node_table_value_search_replace
    :noindex:

.. class:: TableValueSearchReplaceWithTable
    :noindex: